/*
   Copyright 2010 Sun Microsystems, Inc.
   All rights reserved. Use is subject to license terms.

   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; version 2 of the License.

   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.

   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301  USA
*/

package testsuite.clusterj;

import com.mysql.clusterj.query.Predicate;

import testsuite.clusterj.model.AllPrimitives;

/** Query for conditions beyond index values. Additional conditions
 * are represented by multiple predicates joined via AND and OR.
 * This test is based on QueryAllPrimitivesTest.
 */
public class QueryExtraConditionsTest extends AbstractQueryTest {

    @Override
    public Class<?> getInstanceType() {
        return AllPrimitives.class;
    }

    @Override
    void createInstances(int number) {
        createAllPrimitivesInstances(10);
    }

    /** Test queries with extra conditions using AllPrimitives.
drop table if exists allprimitives;
create table allprimitives (
 id int not null primary key,

 int_not_null_hash int not null,
 int_not_null_btree int not null,
 int_not_null_both int not null,
 int_not_null_none int not null,
 int_null_hash int,
 int_null_btree int,
 int_null_both int,
 int_null_none int,

 byte_not_null_hash tinyint not null,
 byte_not_null_btree tinyint not null,
 byte_not_null_both tinyint not null,
 byte_not_null_none tinyint not null,
 byte_null_hash tinyint,
 byte_null_btree tinyint,
 byte_null_both tinyint,
 byte_null_none tinyint,

 short_not_null_hash smallint not null,
 short_not_null_btree smallint not null,
 short_not_null_both smallint not null,
 short_not_null_none smallint not null,
 short_null_hash smallint,
 short_null_btree smallint,
 short_null_both smallint,
 short_null_none smallint,

 long_not_null_hash bigint not null,
 long_not_null_btree bigint not null,
 long_not_null_both bigint not null,
 long_not_null_none bigint not null,
 long_null_hash bigint,
 long_null_btree bigint,
 long_null_both bigint,
 long_null_none bigint
     */
    public void testExtraEqual() {
        equalAnd1ExtraQuery("int_not_null_btree", 8, "int_null_none", extraEqualPredicateProvider, 8, "idx_int_not_null_btree", 8);
        equalAnd1ExtraQuery("int_not_null_btree", 8, "int_null_none", extraEqualPredicateProvider, 9, "idx_int_not_null_btree");

        equalAnd1ExtraQuery("int_not_null_hash", 8, "int_null_none", extraEqualPredicateProvider, 8, "none", 8);
        equalAnd1ExtraQuery("int_not_null_hash", 8, "int_null_none", extraEqualPredicateProvider, 9, "none");

        equalAnd1ExtraQuery("int_not_null_both", 8, "int_null_none", extraEqualPredicateProvider, 8, "idx_int_not_null_both", 8);
        equalAnd1ExtraQuery("int_not_null_both", 8, "int_null_none", extraEqualPredicateProvider, 9, "idx_int_not_null_both");

        equalAnd1ExtraQuery("int_not_null_none", 8, "int_null_none", extraEqualPredicateProvider, 8, "none", 8);
        equalAnd1ExtraQuery("int_not_null_none", 8, "int_null_none", extraEqualPredicateProvider, 9, "none");

        failOnError();        
    }

    public void testExtraBetween() {
        equalAnd2ExtraQuery("int_not_null_btree", 8, "int_null_none", extraBetweenPredicateProvider, 8, 9, "idx_int_not_null_btree", 8);
        equalAnd2ExtraQuery("int_not_null_btree", 8, "int_null_none", extraBetweenPredicateProvider, 6, 7, "idx_int_not_null_btree");

        equalAnd2ExtraQuery("int_not_null_hash", 8, "int_not_null_btree", extraBetweenPredicateProvider, 8, 9, "idx_int_not_null_btree", 8);
        equalAnd2ExtraQuery("int_not_null_hash", 8, "int_not_null_btree", extraBetweenPredicateProvider, 6, 7, "idx_int_not_null_btree");

        equalAnd2ExtraQuery("int_not_null_both", 8, "int_null_none", extraBetweenPredicateProvider, 8, 9, "idx_int_not_null_both", 8);
        equalAnd2ExtraQuery("int_not_null_both", 8, "int_null_none", extraBetweenPredicateProvider, 6, 7, "idx_int_not_null_both");

        equalAnd2ExtraQuery("int_not_null_none", 8, "int_not_null_btree", extraBetweenPredicateProvider, 8, 9, "idx_int_not_null_btree", 8);
        equalAnd2ExtraQuery("int_not_null_none", 8, "int_not_null_btree", extraBetweenPredicateProvider, 6, 7, "idx_int_not_null_btree");

        failOnError();        
    }

}
